package com.itheima.mapper;

import com.itheima.pojo.Member;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface MemberMapper {

    @Select("select * from t_member where phoneNumber=#{phoneNumber}")
    Member findByTelephone(String telephone);

    @Select("insert into t_member(phoneNumber,name,sex,idCard,regTime,password,email) values(#{phoneNumber},#{name},#{sex},#{idCard},#{regTime},#{password},#{email})")
    void addMember(Member member);
}
